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