UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4gkTNNGnGpzqWEepTtCRGYncyC5/w1gGPLf7v/o9L0='
WHERE
key_id = 'f001350b281bb2c4f960b1a3ab3c2cf2200bc5909c1ab3a50c9aaa5139df0eb6'
AND (
token = 'z4gkTNNGnGpzqWEepTtCRGYncyC5/w1gGPLf7v/o9L0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)