SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cdbdb06d6753ab305735ea8ddd7be51552ae798b76ff047ce34f2dbd8dbf7018' 
  AND token = 'lt1oQt2YgbRYbS0glGm+LxFp7NSng4n9VNlbKXFB7ig=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}