UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tMqotkSbvNrancREVOZL+wkrISfBGJvo9INhoESCKqw='
WHERE
key_id = '7ef0e92f3c9542012cf4f8d449fe88915056023c293ceabac4310619af97ec44'
AND (
token = 'tMqotkSbvNrancREVOZL+wkrISfBGJvo9INhoESCKqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)