SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e653c2dde2560f1af6d37a3e4fc77c22bcf71a2b149cd45b8ff3d30b2188ee63' 
  AND token = 'ymVZEJ3j4kQOSQPkmQ/3TF7aXLxWeQBudOlONv8yWa4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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