UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRrnHpQonqqBYTRIXS13OUicM4s23TO/nA48+6HtZnI='
WHERE
key_id = 'd95627b84a8f5d874f44c9ab5b14e64b6abeded670895423b1802d6af3a9efde'
AND (
token = 'HRrnHpQonqqBYTRIXS13OUicM4s23TO/nA48+6HtZnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)