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