UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsMsTXRt3FNaH7TLJ93/AWu7ZO6HBy4/JBEWdkoV36E='
WHERE
key_id = 'b5b986679dccd8d79221894c1dc11b2609b6860ff508f5c81e4accee5f3e46e0'
AND (
token = 'hsMsTXRt3FNaH7TLJ93/AWu7ZO6HBy4/JBEWdkoV36E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)