UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEQIgGI9pBl+HCoJs28HPhjjTrpIw05yvHAT4ixi5KM='
WHERE
key_id = '8f59bb58e7e49d1de12b644634a903c4a9583b3acb51ad9f26644a5c466bb1e1'
AND (
token = 'XEQIgGI9pBl+HCoJs28HPhjjTrpIw05yvHAT4ixi5KM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)