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