UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lOwYHzTQ9WHbkaAbhrW/pKNGMGowAOj7LpkFUsns08='
WHERE
key_id = 'a823f09f72fcb97e6638b95db147846fdcc8ca35719c4c2128c601d9722bd72b'
AND (
token = '4lOwYHzTQ9WHbkaAbhrW/pKNGMGowAOj7LpkFUsns08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)