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