UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhCBCz85MQ6u3Ho3CSDvgbpf3jhW86e97yroSl7bNCw='
WHERE
key_id = '802b7e52674f16364f185313cc9b7b94b4b4f84e4298ea7ac7da00c177c95d3f'
AND (
token = 'mhCBCz85MQ6u3Ho3CSDvgbpf3jhW86e97yroSl7bNCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)