UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mRp3MBsx3/eepu77ix86d1vy4wrLTNETwLq2Hf/b88A='
WHERE
key_id = 'c4ce9b7a22d30266502b742a7c5faa00a21112bd0a8fe84d6cb9d88b58d83ce7'
AND (
token = 'mRp3MBsx3/eepu77ix86d1vy4wrLTNETwLq2Hf/b88A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)