UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LBcSeB4PG4f/OJPiPy3hVE0iiZnNIG407fO9TiFJYI='
WHERE
key_id = '8ae4895cfa85e6abcec888a1bb8ea343be05a2cf2d406682ea884fbb44f97e6d'
AND (
token = '9LBcSeB4PG4f/OJPiPy3hVE0iiZnNIG407fO9TiFJYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)