UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e1Oa5A7IGpvFxvyQwvzJDj7d1FSjB7W30IMK8Znfgg4='
WHERE
key_id = '47c6c5b19d199bf4eee37f904569bec6543f0e4f0ecf6eeb98585ffe6c3cae13'
AND (
token = 'e1Oa5A7IGpvFxvyQwvzJDj7d1FSjB7W30IMK8Znfgg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)