UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dD8KO4o9U4JtXoYXD+/I6zVQeLtyre+sKmrXKGOKBVk='
WHERE
key_id = 'be58f1e472c8eab9e519a08cc56a250b9b1b5754e19bb2316a0f00acad7e805a'
AND (
token = 'dD8KO4o9U4JtXoYXD+/I6zVQeLtyre+sKmrXKGOKBVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)