UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdhO7mxULkNWtDJQuHSSnry/BEGs/8cxdOeBKUGu9+w='
WHERE
key_id = 'e74add45dcb32325d3a831ffe6a0ebe2fab04027c61a1ae8c4bf9723859fbb8d'
AND (
token = 'QdhO7mxULkNWtDJQuHSSnry/BEGs/8cxdOeBKUGu9+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)