SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1db483869786a124d75635117351f160ca140fd2e8052aac1a8dcf56e9c456d8' 
  AND token = 'fzr5250U2kBVX4cj/NT3ZivHFY8sPmAQRnkHQKOIdkA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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