UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iKZGtMCayqVnHLKB2m7e5329+p7IiecaBCWGbpX735E='
WHERE
key_id = '47de6c5965b22aa4c93c178aa5c75dd1036aff736b3f582a316e1e70ecca16cc'
AND (
token = 'iKZGtMCayqVnHLKB2m7e5329+p7IiecaBCWGbpX735E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)