UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EzBIcptAiNvArFnudbLa8SQKiPTNSjmJ8gtekzh7wCc='
WHERE
key_id = 'fc348b90403b9c89168d78535f5a176aa8adcd247160aa28a25207c8cca5adf0'
AND (
token = 'EzBIcptAiNvArFnudbLa8SQKiPTNSjmJ8gtekzh7wCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)