UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kr0K9HjG9E1NFTB5ciX5HMPxcCuep3j3677YkxTAuSE='
WHERE
key_id = 'd6cab296d71eaa9ba11e06b44549d9411a636050bfae16e10438a1141fca2475'
AND (
token = 'kr0K9HjG9E1NFTB5ciX5HMPxcCuep3j3677YkxTAuSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)