SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0ec3a629ded2b6d4d6b91ad2de785aa6f1af7a3f7c44a724bf3ab81a9e278ff0' 
  AND token = 'w0SFlql4Vdo2VAqrO5uoq9HKJbEdgVlxHVrW6rm8g1o=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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