UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcuUXA7DhxobkxmHBPOPtfV4tmfB3kix2UJwJoV0aYI='
WHERE
key_id = '1c42e61996a16568183f3ee3e7c39ef8f7168f3518412f8b1654c0ec54fef725'
AND (
token = 'YcuUXA7DhxobkxmHBPOPtfV4tmfB3kix2UJwJoV0aYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)