UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7rLK30oYUL+kDH12K3q8KJlipCOCTAbeMjYg0mxClg='
WHERE
key_id = 'e4f4450312c8eba3dcb6bc6d1df287e076d6d3fccf0919831c8ac15611cc960c'
AND (
token = 'J7rLK30oYUL+kDH12K3q8KJlipCOCTAbeMjYg0mxClg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)