UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '64RTgYHMIUJer531sFAxjQGeKmPxqWLCHcNeBjC9SpE='
WHERE
key_id = 'd064f0d8f16f148ab02003fda87423d90c1d1c64ef6b521b3b9b3efc7c72c612'
AND (
token = '64RTgYHMIUJer531sFAxjQGeKmPxqWLCHcNeBjC9SpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)