UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '23txsVJBP6i/30WFrXLm8+kIoCmImKyWNRLWxJKOwcE='
WHERE
key_id = 'b0c2af773b9edb94d50816d09ee93c4f68981d64936fdc012b90bb5a382cf8cc'
AND (
token = '23txsVJBP6i/30WFrXLm8+kIoCmImKyWNRLWxJKOwcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)