UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TtGipGSXJE7+f2UNwnt8vX7UHSOYJvqqHC37KK9UAdk='
WHERE
key_id = 'bfc61bd97b00702c50f61ac78e83de05f37c3901e3e324907772e0595b84eb19'
AND (
token = 'TtGipGSXJE7+f2UNwnt8vX7UHSOYJvqqHC37KK9UAdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)