UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BeGtR8k8ZPP2jIiIap59K6fkxBgAcCh2LYpfc2727+I='
WHERE
key_id = '86be301c9faeb104d87e07680c1e70bc18f0ae3e791e6642f6155533db139c8a'
AND (
token = 'BeGtR8k8ZPP2jIiIap59K6fkxBgAcCh2LYpfc2727+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)