UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtMRqDDicSQjt7oIfxYVCDb7mOSh54XHVSpA+nV/1ik='
WHERE
key_id = 'b4202ec1b18b7ef981cc8420ff83f19a1275961771eca97d44f27136d952e9c8'
AND (
token = 'XtMRqDDicSQjt7oIfxYVCDb7mOSh54XHVSpA+nV/1ik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)