UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QanJ2Zbimvikhip7LNU2pNYWdGlqmQftOA3Fdov+rus='
WHERE
key_id = 'f1d465999825e7a5a936759d2530e574bf22ba9564489721ee53d90b7180a7f6'
AND (
token = 'QanJ2Zbimvikhip7LNU2pNYWdGlqmQftOA3Fdov+rus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)