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