SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '93cb77ac9a52ab45a2b16f37c385dc87599d2d418b1b9ccd91db55def81634ba' 
  AND token = 'v6rQZdqKkcQwHiYe1j6XJDZO21PNDfDQ1VmhqkbO4eg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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