UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8ymPMpYtwISu/fvEVv8w/FTxfUxXgoWvtjnksO4uFM='
WHERE
key_id = '03a3432c7197564c0613ea90b248505417ce74cac4e29aa08a0717cafa05c9cf'
AND (
token = 'X8ymPMpYtwISu/fvEVv8w/FTxfUxXgoWvtjnksO4uFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)